USE [200Millas]
GO

/****** Object:  StoredProcedure [dbo].[usp_ConsultarUnidadMedida]    Script Date: 10/06/2012 02:22:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<dparedes>
-- Create date: <2012/10/06>
-- Description:	<Consultar Unidad de Medida>
-- =============================================
CREATE PROCEDURE [dbo].[usp_ConsultarUnidadMedida] 
@vcod_um char(3)
AS
BEGIN
	SELECT * FROM [200Millas].dbo.TB_UNIDAD_MEDIDA WHERE COD_UM = @vcod_um;
END

GO


USE [200Millas]
GO

/****** Object:  StoredProcedure [dbo].[usp_ListarUnidadMedida]    Script Date: 10/06/2012 02:22:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<dparedes>
-- Create date: <2012/10/06>
-- Description:	<Listar Unidades de Medida>
-- =============================================
CREATE PROCEDURE [dbo].[usp_ListarUnidadMedida] 
AS
BEGIN
	SELECT * FROM [200Millas].dbo.TB_UNIDAD_MEDIDA;
END

GO



